package app.foodnote.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class MySQLiteHelper extends SQLiteOpenHelper {
	
	public static final String TABLE_FOODNOTE = "foodnote";
	public static final String COLUMN_ID = "_id";
	public static final String FOOD_NAME = "foodname";
	public static final String ADDRESS = "address";
	public static final String PHONE_NUMBER = "phonenumber";
	public static final String CITIES = "cities";
	public static final String OTHER_NOTES = "othernotes";
	public static final String LONGITUDE = "longitude";
	public static final String LATITUDE = "latitude";
	public static final String COUNT_ALL = "countall";
	public static final String COUNT = "count";
	
	
	private static final String DATABASE_NAME = "foodnote.db";
	private static final int DATABASE_VERSION = 1;
	
	//Database creation sql statement
	private static final String DATABASE_CREATE = "CREATE TABLE "
			+ TABLE_FOODNOTE + "(" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," 
			+ FOOD_NAME + " text not null," 
			+ ADDRESS + " text not null,"
			+ CITIES + " text not null,"
			+ PHONE_NUMBER + " text,"
			+ OTHER_NOTES + " text,"
			+ LONGITUDE + " REAL,"
			+ LATITUDE + " REAL);"
			;

	public MySQLiteHelper(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL(DATABASE_CREATE);
	}
	
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		Log.w(MySQLiteHelper.class.getName(),
				"Upgrading database from version " + oldVersion + " to"
				+ newVersion + ", which will destroy all old data");
		db.execSQL("DROP TABLE IF EXISTS " + TABLE_FOODNOTE);
		onCreate(db);
	}
	
}
